package com.hrd.mybatis.bean.auto;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class TClientExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected int limitStart = -1;

    protected int limitEnd = -1;

    public TClientExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setLimitStart(int limitStart) {
        this.limitStart=limitStart;
    }

    public int getLimitStart() {
        return limitStart;
    }

    public void setLimitEnd(int limitEnd) {
        this.limitEnd=limitEnd;
    }

    public int getLimitEnd() {
        return limitEnd;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andFidIsNull() {
            addCriterion("fID is null");
            return (Criteria) this;
        }

        public Criteria andFidIsNotNull() {
            addCriterion("fID is not null");
            return (Criteria) this;
        }

        public Criteria andFidEqualTo(Integer value) {
            addCriterion("fID =", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidNotEqualTo(Integer value) {
            addCriterion("fID <>", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidGreaterThan(Integer value) {
            addCriterion("fID >", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fID >=", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidLessThan(Integer value) {
            addCriterion("fID <", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidLessThanOrEqualTo(Integer value) {
            addCriterion("fID <=", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidIn(List<Integer> values) {
            addCriterion("fID in", values, "fid");
            return (Criteria) this;
        }

        public Criteria andFidNotIn(List<Integer> values) {
            addCriterion("fID not in", values, "fid");
            return (Criteria) this;
        }

        public Criteria andFidBetween(Integer value1, Integer value2) {
            addCriterion("fID between", value1, value2, "fid");
            return (Criteria) this;
        }

        public Criteria andFidNotBetween(Integer value1, Integer value2) {
            addCriterion("fID not between", value1, value2, "fid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidIsNull() {
            addCriterion("fItemClassID is null");
            return (Criteria) this;
        }

        public Criteria andFitemclassidIsNotNull() {
            addCriterion("fItemClassID is not null");
            return (Criteria) this;
        }

        public Criteria andFitemclassidEqualTo(Integer value) {
            addCriterion("fItemClassID =", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidNotEqualTo(Integer value) {
            addCriterion("fItemClassID <>", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidGreaterThan(Integer value) {
            addCriterion("fItemClassID >", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fItemClassID >=", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidLessThan(Integer value) {
            addCriterion("fItemClassID <", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidLessThanOrEqualTo(Integer value) {
            addCriterion("fItemClassID <=", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidIn(List<Integer> values) {
            addCriterion("fItemClassID in", values, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidNotIn(List<Integer> values) {
            addCriterion("fItemClassID not in", values, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidBetween(Integer value1, Integer value2) {
            addCriterion("fItemClassID between", value1, value2, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidNotBetween(Integer value1, Integer value2) {
            addCriterion("fItemClassID not between", value1, value2, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidIsNull() {
            addCriterion("fCompanyID is null");
            return (Criteria) this;
        }

        public Criteria andFcompanyidIsNotNull() {
            addCriterion("fCompanyID is not null");
            return (Criteria) this;
        }

        public Criteria andFcompanyidEqualTo(Integer value) {
            addCriterion("fCompanyID =", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNotEqualTo(Integer value) {
            addCriterion("fCompanyID <>", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidGreaterThan(Integer value) {
            addCriterion("fCompanyID >", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fCompanyID >=", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidLessThan(Integer value) {
            addCriterion("fCompanyID <", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidLessThanOrEqualTo(Integer value) {
            addCriterion("fCompanyID <=", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidIn(List<Integer> values) {
            addCriterion("fCompanyID in", values, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNotIn(List<Integer> values) {
            addCriterion("fCompanyID not in", values, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidBetween(Integer value1, Integer value2) {
            addCriterion("fCompanyID between", value1, value2, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNotBetween(Integer value1, Integer value2) {
            addCriterion("fCompanyID not between", value1, value2, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFnoIsNull() {
            addCriterion("fNO is null");
            return (Criteria) this;
        }

        public Criteria andFnoIsNotNull() {
            addCriterion("fNO is not null");
            return (Criteria) this;
        }

        public Criteria andFnoEqualTo(String value) {
            addCriterion("fNO =", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoNotEqualTo(String value) {
            addCriterion("fNO <>", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoGreaterThan(String value) {
            addCriterion("fNO >", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoGreaterThanOrEqualTo(String value) {
            addCriterion("fNO >=", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoLessThan(String value) {
            addCriterion("fNO <", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoLessThanOrEqualTo(String value) {
            addCriterion("fNO <=", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoLike(String value) {
            addCriterion("fNO like", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoNotLike(String value) {
            addCriterion("fNO not like", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoIn(List<String> values) {
            addCriterion("fNO in", values, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoNotIn(List<String> values) {
            addCriterion("fNO not in", values, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoBetween(String value1, String value2) {
            addCriterion("fNO between", value1, value2, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoNotBetween(String value1, String value2) {
            addCriterion("fNO not between", value1, value2, "fno");
            return (Criteria) this;
        }

        public Criteria andFnameIsNull() {
            addCriterion("fName is null");
            return (Criteria) this;
        }

        public Criteria andFnameIsNotNull() {
            addCriterion("fName is not null");
            return (Criteria) this;
        }

        public Criteria andFnameEqualTo(String value) {
            addCriterion("fName =", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameNotEqualTo(String value) {
            addCriterion("fName <>", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameGreaterThan(String value) {
            addCriterion("fName >", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameGreaterThanOrEqualTo(String value) {
            addCriterion("fName >=", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameLessThan(String value) {
            addCriterion("fName <", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameLessThanOrEqualTo(String value) {
            addCriterion("fName <=", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameLike(String value) {
            addCriterion("fName like", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameNotLike(String value) {
            addCriterion("fName not like", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameIn(List<String> values) {
            addCriterion("fName in", values, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameNotIn(List<String> values) {
            addCriterion("fName not in", values, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameBetween(String value1, String value2) {
            addCriterion("fName between", value1, value2, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameNotBetween(String value1, String value2) {
            addCriterion("fName not between", value1, value2, "fname");
            return (Criteria) this;
        }

        public Criteria andFsexidIsNull() {
            addCriterion("fSexID is null");
            return (Criteria) this;
        }

        public Criteria andFsexidIsNotNull() {
            addCriterion("fSexID is not null");
            return (Criteria) this;
        }

        public Criteria andFsexidEqualTo(Integer value) {
            addCriterion("fSexID =", value, "fsexid");
            return (Criteria) this;
        }

        public Criteria andFsexidNotEqualTo(Integer value) {
            addCriterion("fSexID <>", value, "fsexid");
            return (Criteria) this;
        }

        public Criteria andFsexidGreaterThan(Integer value) {
            addCriterion("fSexID >", value, "fsexid");
            return (Criteria) this;
        }

        public Criteria andFsexidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fSexID >=", value, "fsexid");
            return (Criteria) this;
        }

        public Criteria andFsexidLessThan(Integer value) {
            addCriterion("fSexID <", value, "fsexid");
            return (Criteria) this;
        }

        public Criteria andFsexidLessThanOrEqualTo(Integer value) {
            addCriterion("fSexID <=", value, "fsexid");
            return (Criteria) this;
        }

        public Criteria andFsexidIn(List<Integer> values) {
            addCriterion("fSexID in", values, "fsexid");
            return (Criteria) this;
        }

        public Criteria andFsexidNotIn(List<Integer> values) {
            addCriterion("fSexID not in", values, "fsexid");
            return (Criteria) this;
        }

        public Criteria andFsexidBetween(Integer value1, Integer value2) {
            addCriterion("fSexID between", value1, value2, "fsexid");
            return (Criteria) this;
        }

        public Criteria andFsexidNotBetween(Integer value1, Integer value2) {
            addCriterion("fSexID not between", value1, value2, "fsexid");
            return (Criteria) this;
        }

        public Criteria andFbirthdayIsNull() {
            addCriterion("fBirthday is null");
            return (Criteria) this;
        }

        public Criteria andFbirthdayIsNotNull() {
            addCriterion("fBirthday is not null");
            return (Criteria) this;
        }

        public Criteria andFbirthdayEqualTo(Date value) {
            addCriterion("fBirthday =", value, "fbirthday");
            return (Criteria) this;
        }

        public Criteria andFbirthdayNotEqualTo(Date value) {
            addCriterion("fBirthday <>", value, "fbirthday");
            return (Criteria) this;
        }

        public Criteria andFbirthdayGreaterThan(Date value) {
            addCriterion("fBirthday >", value, "fbirthday");
            return (Criteria) this;
        }

        public Criteria andFbirthdayGreaterThanOrEqualTo(Date value) {
            addCriterion("fBirthday >=", value, "fbirthday");
            return (Criteria) this;
        }

        public Criteria andFbirthdayLessThan(Date value) {
            addCriterion("fBirthday <", value, "fbirthday");
            return (Criteria) this;
        }

        public Criteria andFbirthdayLessThanOrEqualTo(Date value) {
            addCriterion("fBirthday <=", value, "fbirthday");
            return (Criteria) this;
        }

        public Criteria andFbirthdayIn(List<Date> values) {
            addCriterion("fBirthday in", values, "fbirthday");
            return (Criteria) this;
        }

        public Criteria andFbirthdayNotIn(List<Date> values) {
            addCriterion("fBirthday not in", values, "fbirthday");
            return (Criteria) this;
        }

        public Criteria andFbirthdayBetween(Date value1, Date value2) {
            addCriterion("fBirthday between", value1, value2, "fbirthday");
            return (Criteria) this;
        }

        public Criteria andFbirthdayNotBetween(Date value1, Date value2) {
            addCriterion("fBirthday not between", value1, value2, "fbirthday");
            return (Criteria) this;
        }

        public Criteria andFcardtypeidIsNull() {
            addCriterion("fCardTypeID is null");
            return (Criteria) this;
        }

        public Criteria andFcardtypeidIsNotNull() {
            addCriterion("fCardTypeID is not null");
            return (Criteria) this;
        }

        public Criteria andFcardtypeidEqualTo(Integer value) {
            addCriterion("fCardTypeID =", value, "fcardtypeid");
            return (Criteria) this;
        }

        public Criteria andFcardtypeidNotEqualTo(Integer value) {
            addCriterion("fCardTypeID <>", value, "fcardtypeid");
            return (Criteria) this;
        }

        public Criteria andFcardtypeidGreaterThan(Integer value) {
            addCriterion("fCardTypeID >", value, "fcardtypeid");
            return (Criteria) this;
        }

        public Criteria andFcardtypeidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fCardTypeID >=", value, "fcardtypeid");
            return (Criteria) this;
        }

        public Criteria andFcardtypeidLessThan(Integer value) {
            addCriterion("fCardTypeID <", value, "fcardtypeid");
            return (Criteria) this;
        }

        public Criteria andFcardtypeidLessThanOrEqualTo(Integer value) {
            addCriterion("fCardTypeID <=", value, "fcardtypeid");
            return (Criteria) this;
        }

        public Criteria andFcardtypeidIn(List<Integer> values) {
            addCriterion("fCardTypeID in", values, "fcardtypeid");
            return (Criteria) this;
        }

        public Criteria andFcardtypeidNotIn(List<Integer> values) {
            addCriterion("fCardTypeID not in", values, "fcardtypeid");
            return (Criteria) this;
        }

        public Criteria andFcardtypeidBetween(Integer value1, Integer value2) {
            addCriterion("fCardTypeID between", value1, value2, "fcardtypeid");
            return (Criteria) this;
        }

        public Criteria andFcardtypeidNotBetween(Integer value1, Integer value2) {
            addCriterion("fCardTypeID not between", value1, value2, "fcardtypeid");
            return (Criteria) this;
        }

        public Criteria andFcardidIsNull() {
            addCriterion("fCardID is null");
            return (Criteria) this;
        }

        public Criteria andFcardidIsNotNull() {
            addCriterion("fCardID is not null");
            return (Criteria) this;
        }

        public Criteria andFcardidEqualTo(String value) {
            addCriterion("fCardID =", value, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidNotEqualTo(String value) {
            addCriterion("fCardID <>", value, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidGreaterThan(String value) {
            addCriterion("fCardID >", value, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidGreaterThanOrEqualTo(String value) {
            addCriterion("fCardID >=", value, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidLessThan(String value) {
            addCriterion("fCardID <", value, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidLessThanOrEqualTo(String value) {
            addCriterion("fCardID <=", value, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidLike(String value) {
            addCriterion("fCardID like", value, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidNotLike(String value) {
            addCriterion("fCardID not like", value, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidIn(List<String> values) {
            addCriterion("fCardID in", values, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidNotIn(List<String> values) {
            addCriterion("fCardID not in", values, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidBetween(String value1, String value2) {
            addCriterion("fCardID between", value1, value2, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidNotBetween(String value1, String value2) {
            addCriterion("fCardID not between", value1, value2, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFmarryidIsNull() {
            addCriterion("fMarryID is null");
            return (Criteria) this;
        }

        public Criteria andFmarryidIsNotNull() {
            addCriterion("fMarryID is not null");
            return (Criteria) this;
        }

        public Criteria andFmarryidEqualTo(Integer value) {
            addCriterion("fMarryID =", value, "fmarryid");
            return (Criteria) this;
        }

        public Criteria andFmarryidNotEqualTo(Integer value) {
            addCriterion("fMarryID <>", value, "fmarryid");
            return (Criteria) this;
        }

        public Criteria andFmarryidGreaterThan(Integer value) {
            addCriterion("fMarryID >", value, "fmarryid");
            return (Criteria) this;
        }

        public Criteria andFmarryidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fMarryID >=", value, "fmarryid");
            return (Criteria) this;
        }

        public Criteria andFmarryidLessThan(Integer value) {
            addCriterion("fMarryID <", value, "fmarryid");
            return (Criteria) this;
        }

        public Criteria andFmarryidLessThanOrEqualTo(Integer value) {
            addCriterion("fMarryID <=", value, "fmarryid");
            return (Criteria) this;
        }

        public Criteria andFmarryidIn(List<Integer> values) {
            addCriterion("fMarryID in", values, "fmarryid");
            return (Criteria) this;
        }

        public Criteria andFmarryidNotIn(List<Integer> values) {
            addCriterion("fMarryID not in", values, "fmarryid");
            return (Criteria) this;
        }

        public Criteria andFmarryidBetween(Integer value1, Integer value2) {
            addCriterion("fMarryID between", value1, value2, "fmarryid");
            return (Criteria) this;
        }

        public Criteria andFmarryidNotBetween(Integer value1, Integer value2) {
            addCriterion("fMarryID not between", value1, value2, "fmarryid");
            return (Criteria) this;
        }

        public Criteria andFaddressIsNull() {
            addCriterion("fAddress is null");
            return (Criteria) this;
        }

        public Criteria andFaddressIsNotNull() {
            addCriterion("fAddress is not null");
            return (Criteria) this;
        }

        public Criteria andFaddressEqualTo(String value) {
            addCriterion("fAddress =", value, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressNotEqualTo(String value) {
            addCriterion("fAddress <>", value, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressGreaterThan(String value) {
            addCriterion("fAddress >", value, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressGreaterThanOrEqualTo(String value) {
            addCriterion("fAddress >=", value, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressLessThan(String value) {
            addCriterion("fAddress <", value, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressLessThanOrEqualTo(String value) {
            addCriterion("fAddress <=", value, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressLike(String value) {
            addCriterion("fAddress like", value, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressNotLike(String value) {
            addCriterion("fAddress not like", value, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressIn(List<String> values) {
            addCriterion("fAddress in", values, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressNotIn(List<String> values) {
            addCriterion("fAddress not in", values, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressBetween(String value1, String value2) {
            addCriterion("fAddress between", value1, value2, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressNotBetween(String value1, String value2) {
            addCriterion("fAddress not between", value1, value2, "faddress");
            return (Criteria) this;
        }

        public Criteria andFmonthincomeIsNull() {
            addCriterion("fMonthIncome is null");
            return (Criteria) this;
        }

        public Criteria andFmonthincomeIsNotNull() {
            addCriterion("fMonthIncome is not null");
            return (Criteria) this;
        }

        public Criteria andFmonthincomeEqualTo(BigDecimal value) {
            addCriterion("fMonthIncome =", value, "fmonthincome");
            return (Criteria) this;
        }

        public Criteria andFmonthincomeNotEqualTo(BigDecimal value) {
            addCriterion("fMonthIncome <>", value, "fmonthincome");
            return (Criteria) this;
        }

        public Criteria andFmonthincomeGreaterThan(BigDecimal value) {
            addCriterion("fMonthIncome >", value, "fmonthincome");
            return (Criteria) this;
        }

        public Criteria andFmonthincomeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fMonthIncome >=", value, "fmonthincome");
            return (Criteria) this;
        }

        public Criteria andFmonthincomeLessThan(BigDecimal value) {
            addCriterion("fMonthIncome <", value, "fmonthincome");
            return (Criteria) this;
        }

        public Criteria andFmonthincomeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fMonthIncome <=", value, "fmonthincome");
            return (Criteria) this;
        }

        public Criteria andFmonthincomeIn(List<BigDecimal> values) {
            addCriterion("fMonthIncome in", values, "fmonthincome");
            return (Criteria) this;
        }

        public Criteria andFmonthincomeNotIn(List<BigDecimal> values) {
            addCriterion("fMonthIncome not in", values, "fmonthincome");
            return (Criteria) this;
        }

        public Criteria andFmonthincomeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fMonthIncome between", value1, value2, "fmonthincome");
            return (Criteria) this;
        }

        public Criteria andFmonthincomeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fMonthIncome not between", value1, value2, "fmonthincome");
            return (Criteria) this;
        }

        public Criteria andFworkphoneIsNull() {
            addCriterion("fWorkPhone is null");
            return (Criteria) this;
        }

        public Criteria andFworkphoneIsNotNull() {
            addCriterion("fWorkPhone is not null");
            return (Criteria) this;
        }

        public Criteria andFworkphoneEqualTo(String value) {
            addCriterion("fWorkPhone =", value, "fworkphone");
            return (Criteria) this;
        }

        public Criteria andFworkphoneNotEqualTo(String value) {
            addCriterion("fWorkPhone <>", value, "fworkphone");
            return (Criteria) this;
        }

        public Criteria andFworkphoneGreaterThan(String value) {
            addCriterion("fWorkPhone >", value, "fworkphone");
            return (Criteria) this;
        }

        public Criteria andFworkphoneGreaterThanOrEqualTo(String value) {
            addCriterion("fWorkPhone >=", value, "fworkphone");
            return (Criteria) this;
        }

        public Criteria andFworkphoneLessThan(String value) {
            addCriterion("fWorkPhone <", value, "fworkphone");
            return (Criteria) this;
        }

        public Criteria andFworkphoneLessThanOrEqualTo(String value) {
            addCriterion("fWorkPhone <=", value, "fworkphone");
            return (Criteria) this;
        }

        public Criteria andFworkphoneLike(String value) {
            addCriterion("fWorkPhone like", value, "fworkphone");
            return (Criteria) this;
        }

        public Criteria andFworkphoneNotLike(String value) {
            addCriterion("fWorkPhone not like", value, "fworkphone");
            return (Criteria) this;
        }

        public Criteria andFworkphoneIn(List<String> values) {
            addCriterion("fWorkPhone in", values, "fworkphone");
            return (Criteria) this;
        }

        public Criteria andFworkphoneNotIn(List<String> values) {
            addCriterion("fWorkPhone not in", values, "fworkphone");
            return (Criteria) this;
        }

        public Criteria andFworkphoneBetween(String value1, String value2) {
            addCriterion("fWorkPhone between", value1, value2, "fworkphone");
            return (Criteria) this;
        }

        public Criteria andFworkphoneNotBetween(String value1, String value2) {
            addCriterion("fWorkPhone not between", value1, value2, "fworkphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneIsNull() {
            addCriterion("fHandPhone is null");
            return (Criteria) this;
        }

        public Criteria andFhandphoneIsNotNull() {
            addCriterion("fHandPhone is not null");
            return (Criteria) this;
        }

        public Criteria andFhandphoneEqualTo(String value) {
            addCriterion("fHandPhone =", value, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneNotEqualTo(String value) {
            addCriterion("fHandPhone <>", value, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneGreaterThan(String value) {
            addCriterion("fHandPhone >", value, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneGreaterThanOrEqualTo(String value) {
            addCriterion("fHandPhone >=", value, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneLessThan(String value) {
            addCriterion("fHandPhone <", value, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneLessThanOrEqualTo(String value) {
            addCriterion("fHandPhone <=", value, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneLike(String value) {
            addCriterion("fHandPhone like", value, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneNotLike(String value) {
            addCriterion("fHandPhone not like", value, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneIn(List<String> values) {
            addCriterion("fHandPhone in", values, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneNotIn(List<String> values) {
            addCriterion("fHandPhone not in", values, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneBetween(String value1, String value2) {
            addCriterion("fHandPhone between", value1, value2, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneNotBetween(String value1, String value2) {
            addCriterion("fHandPhone not between", value1, value2, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneIsNull() {
            addCriterion("fFamilyPhone is null");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneIsNotNull() {
            addCriterion("fFamilyPhone is not null");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneEqualTo(String value) {
            addCriterion("fFamilyPhone =", value, "ffamilyphone");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneNotEqualTo(String value) {
            addCriterion("fFamilyPhone <>", value, "ffamilyphone");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneGreaterThan(String value) {
            addCriterion("fFamilyPhone >", value, "ffamilyphone");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneGreaterThanOrEqualTo(String value) {
            addCriterion("fFamilyPhone >=", value, "ffamilyphone");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneLessThan(String value) {
            addCriterion("fFamilyPhone <", value, "ffamilyphone");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneLessThanOrEqualTo(String value) {
            addCriterion("fFamilyPhone <=", value, "ffamilyphone");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneLike(String value) {
            addCriterion("fFamilyPhone like", value, "ffamilyphone");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneNotLike(String value) {
            addCriterion("fFamilyPhone not like", value, "ffamilyphone");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneIn(List<String> values) {
            addCriterion("fFamilyPhone in", values, "ffamilyphone");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneNotIn(List<String> values) {
            addCriterion("fFamilyPhone not in", values, "ffamilyphone");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneBetween(String value1, String value2) {
            addCriterion("fFamilyPhone between", value1, value2, "ffamilyphone");
            return (Criteria) this;
        }

        public Criteria andFfamilyphoneNotBetween(String value1, String value2) {
            addCriterion("fFamilyPhone not between", value1, value2, "ffamilyphone");
            return (Criteria) this;
        }

        public Criteria andFemailIsNull() {
            addCriterion("fEMail is null");
            return (Criteria) this;
        }

        public Criteria andFemailIsNotNull() {
            addCriterion("fEMail is not null");
            return (Criteria) this;
        }

        public Criteria andFemailEqualTo(String value) {
            addCriterion("fEMail =", value, "femail");
            return (Criteria) this;
        }

        public Criteria andFemailNotEqualTo(String value) {
            addCriterion("fEMail <>", value, "femail");
            return (Criteria) this;
        }

        public Criteria andFemailGreaterThan(String value) {
            addCriterion("fEMail >", value, "femail");
            return (Criteria) this;
        }

        public Criteria andFemailGreaterThanOrEqualTo(String value) {
            addCriterion("fEMail >=", value, "femail");
            return (Criteria) this;
        }

        public Criteria andFemailLessThan(String value) {
            addCriterion("fEMail <", value, "femail");
            return (Criteria) this;
        }

        public Criteria andFemailLessThanOrEqualTo(String value) {
            addCriterion("fEMail <=", value, "femail");
            return (Criteria) this;
        }

        public Criteria andFemailLike(String value) {
            addCriterion("fEMail like", value, "femail");
            return (Criteria) this;
        }

        public Criteria andFemailNotLike(String value) {
            addCriterion("fEMail not like", value, "femail");
            return (Criteria) this;
        }

        public Criteria andFemailIn(List<String> values) {
            addCriterion("fEMail in", values, "femail");
            return (Criteria) this;
        }

        public Criteria andFemailNotIn(List<String> values) {
            addCriterion("fEMail not in", values, "femail");
            return (Criteria) this;
        }

        public Criteria andFemailBetween(String value1, String value2) {
            addCriterion("fEMail between", value1, value2, "femail");
            return (Criteria) this;
        }

        public Criteria andFemailNotBetween(String value1, String value2) {
            addCriterion("fEMail not between", value1, value2, "femail");
            return (Criteria) this;
        }

        public Criteria andFstatusIsNull() {
            addCriterion("fStatus is null");
            return (Criteria) this;
        }

        public Criteria andFstatusIsNotNull() {
            addCriterion("fStatus is not null");
            return (Criteria) this;
        }

        private Criteria andFstatusEqualTo_back(Boolean value) {
            addCriterion("fStatus =", value, "fstatus");
            return (Criteria) this;
        }

        private Criteria andFstatusNotEqualTo_back(Boolean value) {
            addCriterion("fStatus <>", value, "fstatus");
            return (Criteria) this;
        }

        private Criteria andFstatusGreaterThan_back(Boolean value) {
            addCriterion("fStatus >", value, "fstatus");
            return (Criteria) this;
        }

        private Criteria andFstatusGreaterThanOrEqualTo_back(Boolean value) {
            addCriterion("fStatus >=", value, "fstatus");
            return (Criteria) this;
        }

        private Criteria andFstatusLessThan_back(Boolean value) {
            addCriterion("fStatus <", value, "fstatus");
            return (Criteria) this;
        }

        private Criteria andFstatusLessThanOrEqualTo_back(Boolean value) {
            addCriterion("fStatus <=", value, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusIn(List<Boolean> values) {
            addCriterion("fStatus in", values, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusNotIn(List<Boolean> values) {
            addCriterion("fStatus not in", values, "fstatus");
            return (Criteria) this;
        }

        private Criteria andFstatusBetween_back(Boolean value1, Boolean value2) {
            addCriterion("fStatus between", value1, value2, "fstatus");
            return (Criteria) this;
        }

        private Criteria andFstatusNotBetween_back(Boolean value1, Boolean value2) {
            addCriterion("fStatus not between", value1, value2, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidIsNull() {
            addCriterion("fRunStatusID is null");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidIsNotNull() {
            addCriterion("fRunStatusID is not null");
            return (Criteria) this;
        }

        private Criteria andFrunstatusidEqualTo_back(Byte value) {
            addCriterion("fRunStatusID =", value, "frunstatusid");
            return (Criteria) this;
        }

        private Criteria andFrunstatusidNotEqualTo_back(Byte value) {
            addCriterion("fRunStatusID <>", value, "frunstatusid");
            return (Criteria) this;
        }

        private Criteria andFrunstatusidGreaterThan_back(Byte value) {
            addCriterion("fRunStatusID >", value, "frunstatusid");
            return (Criteria) this;
        }

        private Criteria andFrunstatusidGreaterThanOrEqualTo_back(Byte value) {
            addCriterion("fRunStatusID >=", value, "frunstatusid");
            return (Criteria) this;
        }

        private Criteria andFrunstatusidLessThan_back(Byte value) {
            addCriterion("fRunStatusID <", value, "frunstatusid");
            return (Criteria) this;
        }

        private Criteria andFrunstatusidLessThanOrEqualTo_back(Byte value) {
            addCriterion("fRunStatusID <=", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidIn(List<Byte> values) {
            addCriterion("fRunStatusID in", values, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidNotIn(List<Byte> values) {
            addCriterion("fRunStatusID not in", values, "frunstatusid");
            return (Criteria) this;
        }

        private Criteria andFrunstatusidBetween_back(Byte value1, Byte value2) {
            addCriterion("fRunStatusID between", value1, value2, "frunstatusid");
            return (Criteria) this;
        }

        private Criteria andFrunstatusidNotBetween_back(Byte value1, Byte value2) {
            addCriterion("fRunStatusID not between", value1, value2, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidIsNull() {
            addCriterion("fStatusID is null");
            return (Criteria) this;
        }

        public Criteria andFstatusidIsNotNull() {
            addCriterion("fStatusID is not null");
            return (Criteria) this;
        }

        private Criteria andFstatusidEqualTo_back(Byte value) {
            addCriterion("fStatusID =", value, "fstatusid");
            return (Criteria) this;
        }

        private Criteria andFstatusidNotEqualTo_back(Byte value) {
            addCriterion("fStatusID <>", value, "fstatusid");
            return (Criteria) this;
        }

        private Criteria andFstatusidGreaterThan_back(Byte value) {
            addCriterion("fStatusID >", value, "fstatusid");
            return (Criteria) this;
        }

        private Criteria andFstatusidGreaterThanOrEqualTo_back(Byte value) {
            addCriterion("fStatusID >=", value, "fstatusid");
            return (Criteria) this;
        }

        private Criteria andFstatusidLessThan_back(Byte value) {
            addCriterion("fStatusID <", value, "fstatusid");
            return (Criteria) this;
        }

        private Criteria andFstatusidLessThanOrEqualTo_back(Byte value) {
            addCriterion("fStatusID <=", value, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidIn(List<Byte> values) {
            addCriterion("fStatusID in", values, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidNotIn(List<Byte> values) {
            addCriterion("fStatusID not in", values, "fstatusid");
            return (Criteria) this;
        }

        private Criteria andFstatusidBetween_back(Byte value1, Byte value2) {
            addCriterion("fStatusID between", value1, value2, "fstatusid");
            return (Criteria) this;
        }

        private Criteria andFstatusidNotBetween_back(Byte value1, Byte value2) {
            addCriterion("fStatusID not between", value1, value2, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridIsNull() {
            addCriterion("fOperUserID is null");
            return (Criteria) this;
        }

        public Criteria andFoperuseridIsNotNull() {
            addCriterion("fOperUserID is not null");
            return (Criteria) this;
        }

        public Criteria andFoperuseridEqualTo(Integer value) {
            addCriterion("fOperUserID =", value, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridNotEqualTo(Integer value) {
            addCriterion("fOperUserID <>", value, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridGreaterThan(Integer value) {
            addCriterion("fOperUserID >", value, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridGreaterThanOrEqualTo(Integer value) {
            addCriterion("fOperUserID >=", value, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridLessThan(Integer value) {
            addCriterion("fOperUserID <", value, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridLessThanOrEqualTo(Integer value) {
            addCriterion("fOperUserID <=", value, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridIn(List<Integer> values) {
            addCriterion("fOperUserID in", values, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridNotIn(List<Integer> values) {
            addCriterion("fOperUserID not in", values, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridBetween(Integer value1, Integer value2) {
            addCriterion("fOperUserID between", value1, value2, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridNotBetween(Integer value1, Integer value2) {
            addCriterion("fOperUserID not between", value1, value2, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperdateIsNull() {
            addCriterion("fOperDate is null");
            return (Criteria) this;
        }

        public Criteria andFoperdateIsNotNull() {
            addCriterion("fOperDate is not null");
            return (Criteria) this;
        }

        public Criteria andFoperdateEqualTo(Date value) {
            addCriterion("fOperDate =", value, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateNotEqualTo(Date value) {
            addCriterion("fOperDate <>", value, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateGreaterThan(Date value) {
            addCriterion("fOperDate >", value, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateGreaterThanOrEqualTo(Date value) {
            addCriterion("fOperDate >=", value, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateLessThan(Date value) {
            addCriterion("fOperDate <", value, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateLessThanOrEqualTo(Date value) {
            addCriterion("fOperDate <=", value, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateIn(List<Date> values) {
            addCriterion("fOperDate in", values, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateNotIn(List<Date> values) {
            addCriterion("fOperDate not in", values, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateBetween(Date value1, Date value2) {
            addCriterion("fOperDate between", value1, value2, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateNotBetween(Date value1, Date value2) {
            addCriterion("fOperDate not between", value1, value2, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFmemoIsNull() {
            addCriterion("fMemo is null");
            return (Criteria) this;
        }

        public Criteria andFmemoIsNotNull() {
            addCriterion("fMemo is not null");
            return (Criteria) this;
        }

        public Criteria andFmemoEqualTo(String value) {
            addCriterion("fMemo =", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoNotEqualTo(String value) {
            addCriterion("fMemo <>", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoGreaterThan(String value) {
            addCriterion("fMemo >", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoGreaterThanOrEqualTo(String value) {
            addCriterion("fMemo >=", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoLessThan(String value) {
            addCriterion("fMemo <", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoLessThanOrEqualTo(String value) {
            addCriterion("fMemo <=", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoLike(String value) {
            addCriterion("fMemo like", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoNotLike(String value) {
            addCriterion("fMemo not like", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoIn(List<String> values) {
            addCriterion("fMemo in", values, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoNotIn(List<String> values) {
            addCriterion("fMemo not in", values, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoBetween(String value1, String value2) {
            addCriterion("fMemo between", value1, value2, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoNotBetween(String value1, String value2) {
            addCriterion("fMemo not between", value1, value2, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFdealeridIsNull() {
            addCriterion("fDealerID is null");
            return (Criteria) this;
        }

        public Criteria andFdealeridIsNotNull() {
            addCriterion("fDealerID is not null");
            return (Criteria) this;
        }

        public Criteria andFdealeridEqualTo(Integer value) {
            addCriterion("fDealerID =", value, "fdealerid");
            return (Criteria) this;
        }

        public Criteria andFdealeridNotEqualTo(Integer value) {
            addCriterion("fDealerID <>", value, "fdealerid");
            return (Criteria) this;
        }

        public Criteria andFdealeridGreaterThan(Integer value) {
            addCriterion("fDealerID >", value, "fdealerid");
            return (Criteria) this;
        }

        public Criteria andFdealeridGreaterThanOrEqualTo(Integer value) {
            addCriterion("fDealerID >=", value, "fdealerid");
            return (Criteria) this;
        }

        public Criteria andFdealeridLessThan(Integer value) {
            addCriterion("fDealerID <", value, "fdealerid");
            return (Criteria) this;
        }

        public Criteria andFdealeridLessThanOrEqualTo(Integer value) {
            addCriterion("fDealerID <=", value, "fdealerid");
            return (Criteria) this;
        }

        public Criteria andFdealeridIn(List<Integer> values) {
            addCriterion("fDealerID in", values, "fdealerid");
            return (Criteria) this;
        }

        public Criteria andFdealeridNotIn(List<Integer> values) {
            addCriterion("fDealerID not in", values, "fdealerid");
            return (Criteria) this;
        }

        public Criteria andFdealeridBetween(Integer value1, Integer value2) {
            addCriterion("fDealerID between", value1, value2, "fdealerid");
            return (Criteria) this;
        }

        public Criteria andFdealeridNotBetween(Integer value1, Integer value2) {
            addCriterion("fDealerID not between", value1, value2, "fdealerid");
            return (Criteria) this;
        }

        public Criteria andFcallingIsNull() {
            addCriterion("fCalling is null");
            return (Criteria) this;
        }

        public Criteria andFcallingIsNotNull() {
            addCriterion("fCalling is not null");
            return (Criteria) this;
        }

        public Criteria andFcallingEqualTo(String value) {
            addCriterion("fCalling =", value, "fcalling");
            return (Criteria) this;
        }

        public Criteria andFcallingNotEqualTo(String value) {
            addCriterion("fCalling <>", value, "fcalling");
            return (Criteria) this;
        }

        public Criteria andFcallingGreaterThan(String value) {
            addCriterion("fCalling >", value, "fcalling");
            return (Criteria) this;
        }

        public Criteria andFcallingGreaterThanOrEqualTo(String value) {
            addCriterion("fCalling >=", value, "fcalling");
            return (Criteria) this;
        }

        public Criteria andFcallingLessThan(String value) {
            addCriterion("fCalling <", value, "fcalling");
            return (Criteria) this;
        }

        public Criteria andFcallingLessThanOrEqualTo(String value) {
            addCriterion("fCalling <=", value, "fcalling");
            return (Criteria) this;
        }

        public Criteria andFcallingLike(String value) {
            addCriterion("fCalling like", value, "fcalling");
            return (Criteria) this;
        }

        public Criteria andFcallingNotLike(String value) {
            addCriterion("fCalling not like", value, "fcalling");
            return (Criteria) this;
        }

        public Criteria andFcallingIn(List<String> values) {
            addCriterion("fCalling in", values, "fcalling");
            return (Criteria) this;
        }

        public Criteria andFcallingNotIn(List<String> values) {
            addCriterion("fCalling not in", values, "fcalling");
            return (Criteria) this;
        }

        public Criteria andFcallingBetween(String value1, String value2) {
            addCriterion("fCalling between", value1, value2, "fcalling");
            return (Criteria) this;
        }

        public Criteria andFcallingNotBetween(String value1, String value2) {
            addCriterion("fCalling not between", value1, value2, "fcalling");
            return (Criteria) this;
        }

        public Criteria andFunitattributeidIsNull() {
            addCriterion("fUnitAttributeID is null");
            return (Criteria) this;
        }

        public Criteria andFunitattributeidIsNotNull() {
            addCriterion("fUnitAttributeID is not null");
            return (Criteria) this;
        }

        public Criteria andFunitattributeidEqualTo(Integer value) {
            addCriterion("fUnitAttributeID =", value, "funitattributeid");
            return (Criteria) this;
        }

        public Criteria andFunitattributeidNotEqualTo(Integer value) {
            addCriterion("fUnitAttributeID <>", value, "funitattributeid");
            return (Criteria) this;
        }

        public Criteria andFunitattributeidGreaterThan(Integer value) {
            addCriterion("fUnitAttributeID >", value, "funitattributeid");
            return (Criteria) this;
        }

        public Criteria andFunitattributeidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fUnitAttributeID >=", value, "funitattributeid");
            return (Criteria) this;
        }

        public Criteria andFunitattributeidLessThan(Integer value) {
            addCriterion("fUnitAttributeID <", value, "funitattributeid");
            return (Criteria) this;
        }

        public Criteria andFunitattributeidLessThanOrEqualTo(Integer value) {
            addCriterion("fUnitAttributeID <=", value, "funitattributeid");
            return (Criteria) this;
        }

        public Criteria andFunitattributeidIn(List<Integer> values) {
            addCriterion("fUnitAttributeID in", values, "funitattributeid");
            return (Criteria) this;
        }

        public Criteria andFunitattributeidNotIn(List<Integer> values) {
            addCriterion("fUnitAttributeID not in", values, "funitattributeid");
            return (Criteria) this;
        }

        public Criteria andFunitattributeidBetween(Integer value1, Integer value2) {
            addCriterion("fUnitAttributeID between", value1, value2, "funitattributeid");
            return (Criteria) this;
        }

        public Criteria andFunitattributeidNotBetween(Integer value1, Integer value2) {
            addCriterion("fUnitAttributeID not between", value1, value2, "funitattributeid");
            return (Criteria) this;
        }

        public Criteria andFclientkindidIsNull() {
            addCriterion("fClientKindID is null");
            return (Criteria) this;
        }

        public Criteria andFclientkindidIsNotNull() {
            addCriterion("fClientKindID is not null");
            return (Criteria) this;
        }

        public Criteria andFclientkindidEqualTo(Integer value) {
            addCriterion("fClientKindID =", value, "fclientkindid");
            return (Criteria) this;
        }

        public Criteria andFclientkindidNotEqualTo(Integer value) {
            addCriterion("fClientKindID <>", value, "fclientkindid");
            return (Criteria) this;
        }

        public Criteria andFclientkindidGreaterThan(Integer value) {
            addCriterion("fClientKindID >", value, "fclientkindid");
            return (Criteria) this;
        }

        public Criteria andFclientkindidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fClientKindID >=", value, "fclientkindid");
            return (Criteria) this;
        }

        public Criteria andFclientkindidLessThan(Integer value) {
            addCriterion("fClientKindID <", value, "fclientkindid");
            return (Criteria) this;
        }

        public Criteria andFclientkindidLessThanOrEqualTo(Integer value) {
            addCriterion("fClientKindID <=", value, "fclientkindid");
            return (Criteria) this;
        }

        public Criteria andFclientkindidIn(List<Integer> values) {
            addCriterion("fClientKindID in", values, "fclientkindid");
            return (Criteria) this;
        }

        public Criteria andFclientkindidNotIn(List<Integer> values) {
            addCriterion("fClientKindID not in", values, "fclientkindid");
            return (Criteria) this;
        }

        public Criteria andFclientkindidBetween(Integer value1, Integer value2) {
            addCriterion("fClientKindID between", value1, value2, "fclientkindid");
            return (Criteria) this;
        }

        public Criteria andFclientkindidNotBetween(Integer value1, Integer value2) {
            addCriterion("fClientKindID not between", value1, value2, "fclientkindid");
            return (Criteria) this;
        }

        public Criteria andFmakeuseidIsNull() {
            addCriterion("fMakeUseID is null");
            return (Criteria) this;
        }

        public Criteria andFmakeuseidIsNotNull() {
            addCriterion("fMakeUseID is not null");
            return (Criteria) this;
        }

        public Criteria andFmakeuseidEqualTo(Integer value) {
            addCriterion("fMakeUseID =", value, "fmakeuseid");
            return (Criteria) this;
        }

        public Criteria andFmakeuseidNotEqualTo(Integer value) {
            addCriterion("fMakeUseID <>", value, "fmakeuseid");
            return (Criteria) this;
        }

        public Criteria andFmakeuseidGreaterThan(Integer value) {
            addCriterion("fMakeUseID >", value, "fmakeuseid");
            return (Criteria) this;
        }

        public Criteria andFmakeuseidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fMakeUseID >=", value, "fmakeuseid");
            return (Criteria) this;
        }

        public Criteria andFmakeuseidLessThan(Integer value) {
            addCriterion("fMakeUseID <", value, "fmakeuseid");
            return (Criteria) this;
        }

        public Criteria andFmakeuseidLessThanOrEqualTo(Integer value) {
            addCriterion("fMakeUseID <=", value, "fmakeuseid");
            return (Criteria) this;
        }

        public Criteria andFmakeuseidIn(List<Integer> values) {
            addCriterion("fMakeUseID in", values, "fmakeuseid");
            return (Criteria) this;
        }

        public Criteria andFmakeuseidNotIn(List<Integer> values) {
            addCriterion("fMakeUseID not in", values, "fmakeuseid");
            return (Criteria) this;
        }

        public Criteria andFmakeuseidBetween(Integer value1, Integer value2) {
            addCriterion("fMakeUseID between", value1, value2, "fmakeuseid");
            return (Criteria) this;
        }

        public Criteria andFmakeuseidNotBetween(Integer value1, Integer value2) {
            addCriterion("fMakeUseID not between", value1, value2, "fmakeuseid");
            return (Criteria) this;
        }

        public Criteria andFfamilyaddressIsNull() {
            addCriterion("fFamilyAddress is null");
            return (Criteria) this;
        }

        public Criteria andFfamilyaddressIsNotNull() {
            addCriterion("fFamilyAddress is not null");
            return (Criteria) this;
        }

        public Criteria andFfamilyaddressEqualTo(String value) {
            addCriterion("fFamilyAddress =", value, "ffamilyaddress");
            return (Criteria) this;
        }

        public Criteria andFfamilyaddressNotEqualTo(String value) {
            addCriterion("fFamilyAddress <>", value, "ffamilyaddress");
            return (Criteria) this;
        }

        public Criteria andFfamilyaddressGreaterThan(String value) {
            addCriterion("fFamilyAddress >", value, "ffamilyaddress");
            return (Criteria) this;
        }

        public Criteria andFfamilyaddressGreaterThanOrEqualTo(String value) {
            addCriterion("fFamilyAddress >=", value, "ffamilyaddress");
            return (Criteria) this;
        }

        public Criteria andFfamilyaddressLessThan(String value) {
            addCriterion("fFamilyAddress <", value, "ffamilyaddress");
            return (Criteria) this;
        }

        public Criteria andFfamilyaddressLessThanOrEqualTo(String value) {
            addCriterion("fFamilyAddress <=", value, "ffamilyaddress");
            return (Criteria) this;
        }

        public Criteria andFfamilyaddressLike(String value) {
            addCriterion("fFamilyAddress like", value, "ffamilyaddress");
            return (Criteria) this;
        }

        public Criteria andFfamilyaddressNotLike(String value) {
            addCriterion("fFamilyAddress not like", value, "ffamilyaddress");
            return (Criteria) this;
        }

        public Criteria andFfamilyaddressIn(List<String> values) {
            addCriterion("fFamilyAddress in", values, "ffamilyaddress");
            return (Criteria) this;
        }

        public Criteria andFfamilyaddressNotIn(List<String> values) {
            addCriterion("fFamilyAddress not in", values, "ffamilyaddress");
            return (Criteria) this;
        }

        public Criteria andFfamilyaddressBetween(String value1, String value2) {
            addCriterion("fFamilyAddress between", value1, value2, "ffamilyaddress");
            return (Criteria) this;
        }

        public Criteria andFfamilyaddressNotBetween(String value1, String value2) {
            addCriterion("fFamilyAddress not between", value1, value2, "ffamilyaddress");
            return (Criteria) this;
        }

        public Criteria andFsrc1idIsNull() {
            addCriterion("fSrc1ID is null");
            return (Criteria) this;
        }

        public Criteria andFsrc1idIsNotNull() {
            addCriterion("fSrc1ID is not null");
            return (Criteria) this;
        }

        public Criteria andFsrc1idEqualTo(Integer value) {
            addCriterion("fSrc1ID =", value, "fsrc1id");
            return (Criteria) this;
        }

        public Criteria andFsrc1idNotEqualTo(Integer value) {
            addCriterion("fSrc1ID <>", value, "fsrc1id");
            return (Criteria) this;
        }

        public Criteria andFsrc1idGreaterThan(Integer value) {
            addCriterion("fSrc1ID >", value, "fsrc1id");
            return (Criteria) this;
        }

        public Criteria andFsrc1idGreaterThanOrEqualTo(Integer value) {
            addCriterion("fSrc1ID >=", value, "fsrc1id");
            return (Criteria) this;
        }

        public Criteria andFsrc1idLessThan(Integer value) {
            addCriterion("fSrc1ID <", value, "fsrc1id");
            return (Criteria) this;
        }

        public Criteria andFsrc1idLessThanOrEqualTo(Integer value) {
            addCriterion("fSrc1ID <=", value, "fsrc1id");
            return (Criteria) this;
        }

        public Criteria andFsrc1idIn(List<Integer> values) {
            addCriterion("fSrc1ID in", values, "fsrc1id");
            return (Criteria) this;
        }

        public Criteria andFsrc1idNotIn(List<Integer> values) {
            addCriterion("fSrc1ID not in", values, "fsrc1id");
            return (Criteria) this;
        }

        public Criteria andFsrc1idBetween(Integer value1, Integer value2) {
            addCriterion("fSrc1ID between", value1, value2, "fsrc1id");
            return (Criteria) this;
        }

        public Criteria andFsrc1idNotBetween(Integer value1, Integer value2) {
            addCriterion("fSrc1ID not between", value1, value2, "fsrc1id");
            return (Criteria) this;
        }

        public Criteria andFareaidIsNull() {
            addCriterion("fAreaID is null");
            return (Criteria) this;
        }

        public Criteria andFareaidIsNotNull() {
            addCriterion("fAreaID is not null");
            return (Criteria) this;
        }

        public Criteria andFareaidEqualTo(Integer value) {
            addCriterion("fAreaID =", value, "fareaid");
            return (Criteria) this;
        }

        public Criteria andFareaidNotEqualTo(Integer value) {
            addCriterion("fAreaID <>", value, "fareaid");
            return (Criteria) this;
        }

        public Criteria andFareaidGreaterThan(Integer value) {
            addCriterion("fAreaID >", value, "fareaid");
            return (Criteria) this;
        }

        public Criteria andFareaidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fAreaID >=", value, "fareaid");
            return (Criteria) this;
        }

        public Criteria andFareaidLessThan(Integer value) {
            addCriterion("fAreaID <", value, "fareaid");
            return (Criteria) this;
        }

        public Criteria andFareaidLessThanOrEqualTo(Integer value) {
            addCriterion("fAreaID <=", value, "fareaid");
            return (Criteria) this;
        }

        public Criteria andFareaidIn(List<Integer> values) {
            addCriterion("fAreaID in", values, "fareaid");
            return (Criteria) this;
        }

        public Criteria andFareaidNotIn(List<Integer> values) {
            addCriterion("fAreaID not in", values, "fareaid");
            return (Criteria) this;
        }

        public Criteria andFareaidBetween(Integer value1, Integer value2) {
            addCriterion("fAreaID between", value1, value2, "fareaid");
            return (Criteria) this;
        }

        public Criteria andFareaidNotBetween(Integer value1, Integer value2) {
            addCriterion("fAreaID not between", value1, value2, "fareaid");
            return (Criteria) this;
        }

        public Criteria andFpostmanIsNull() {
            addCriterion("fPostMan is null");
            return (Criteria) this;
        }

        public Criteria andFpostmanIsNotNull() {
            addCriterion("fPostMan is not null");
            return (Criteria) this;
        }

        public Criteria andFpostmanEqualTo(String value) {
            addCriterion("fPostMan =", value, "fpostman");
            return (Criteria) this;
        }

        public Criteria andFpostmanNotEqualTo(String value) {
            addCriterion("fPostMan <>", value, "fpostman");
            return (Criteria) this;
        }

        public Criteria andFpostmanGreaterThan(String value) {
            addCriterion("fPostMan >", value, "fpostman");
            return (Criteria) this;
        }

        public Criteria andFpostmanGreaterThanOrEqualTo(String value) {
            addCriterion("fPostMan >=", value, "fpostman");
            return (Criteria) this;
        }

        public Criteria andFpostmanLessThan(String value) {
            addCriterion("fPostMan <", value, "fpostman");
            return (Criteria) this;
        }

        public Criteria andFpostmanLessThanOrEqualTo(String value) {
            addCriterion("fPostMan <=", value, "fpostman");
            return (Criteria) this;
        }

        public Criteria andFpostmanLike(String value) {
            addCriterion("fPostMan like", value, "fpostman");
            return (Criteria) this;
        }

        public Criteria andFpostmanNotLike(String value) {
            addCriterion("fPostMan not like", value, "fpostman");
            return (Criteria) this;
        }

        public Criteria andFpostmanIn(List<String> values) {
            addCriterion("fPostMan in", values, "fpostman");
            return (Criteria) this;
        }

        public Criteria andFpostmanNotIn(List<String> values) {
            addCriterion("fPostMan not in", values, "fpostman");
            return (Criteria) this;
        }

        public Criteria andFpostmanBetween(String value1, String value2) {
            addCriterion("fPostMan between", value1, value2, "fpostman");
            return (Criteria) this;
        }

        public Criteria andFpostmanNotBetween(String value1, String value2) {
            addCriterion("fPostMan not between", value1, value2, "fpostman");
            return (Criteria) this;
        }

        public Criteria andFchr1IsNull() {
            addCriterion("fChr1 is null");
            return (Criteria) this;
        }

        public Criteria andFchr1IsNotNull() {
            addCriterion("fChr1 is not null");
            return (Criteria) this;
        }

        public Criteria andFchr1EqualTo(String value) {
            addCriterion("fChr1 =", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1NotEqualTo(String value) {
            addCriterion("fChr1 <>", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1GreaterThan(String value) {
            addCriterion("fChr1 >", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1GreaterThanOrEqualTo(String value) {
            addCriterion("fChr1 >=", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1LessThan(String value) {
            addCriterion("fChr1 <", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1LessThanOrEqualTo(String value) {
            addCriterion("fChr1 <=", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1Like(String value) {
            addCriterion("fChr1 like", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1NotLike(String value) {
            addCriterion("fChr1 not like", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1In(List<String> values) {
            addCriterion("fChr1 in", values, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1NotIn(List<String> values) {
            addCriterion("fChr1 not in", values, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1Between(String value1, String value2) {
            addCriterion("fChr1 between", value1, value2, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1NotBetween(String value1, String value2) {
            addCriterion("fChr1 not between", value1, value2, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFfaxphoneIsNull() {
            addCriterion("fFaxPhone is null");
            return (Criteria) this;
        }

        public Criteria andFfaxphoneIsNotNull() {
            addCriterion("fFaxPhone is not null");
            return (Criteria) this;
        }

        public Criteria andFfaxphoneEqualTo(String value) {
            addCriterion("fFaxPhone =", value, "ffaxphone");
            return (Criteria) this;
        }

        public Criteria andFfaxphoneNotEqualTo(String value) {
            addCriterion("fFaxPhone <>", value, "ffaxphone");
            return (Criteria) this;
        }

        public Criteria andFfaxphoneGreaterThan(String value) {
            addCriterion("fFaxPhone >", value, "ffaxphone");
            return (Criteria) this;
        }

        public Criteria andFfaxphoneGreaterThanOrEqualTo(String value) {
            addCriterion("fFaxPhone >=", value, "ffaxphone");
            return (Criteria) this;
        }

        public Criteria andFfaxphoneLessThan(String value) {
            addCriterion("fFaxPhone <", value, "ffaxphone");
            return (Criteria) this;
        }

        public Criteria andFfaxphoneLessThanOrEqualTo(String value) {
            addCriterion("fFaxPhone <=", value, "ffaxphone");
            return (Criteria) this;
        }

        public Criteria andFfaxphoneLike(String value) {
            addCriterion("fFaxPhone like", value, "ffaxphone");
            return (Criteria) this;
        }

        public Criteria andFfaxphoneNotLike(String value) {
            addCriterion("fFaxPhone not like", value, "ffaxphone");
            return (Criteria) this;
        }

        public Criteria andFfaxphoneIn(List<String> values) {
            addCriterion("fFaxPhone in", values, "ffaxphone");
            return (Criteria) this;
        }

        public Criteria andFfaxphoneNotIn(List<String> values) {
            addCriterion("fFaxPhone not in", values, "ffaxphone");
            return (Criteria) this;
        }

        public Criteria andFfaxphoneBetween(String value1, String value2) {
            addCriterion("fFaxPhone between", value1, value2, "ffaxphone");
            return (Criteria) this;
        }

        public Criteria andFfaxphoneNotBetween(String value1, String value2) {
            addCriterion("fFaxPhone not between", value1, value2, "ffaxphone");
            return (Criteria) this;
        }

        public Criteria andFspousephoneIsNull() {
            addCriterion("fSpousePhone is null");
            return (Criteria) this;
        }

        public Criteria andFspousephoneIsNotNull() {
            addCriterion("fSpousePhone is not null");
            return (Criteria) this;
        }

        public Criteria andFspousephoneEqualTo(String value) {
            addCriterion("fSpousePhone =", value, "fspousephone");
            return (Criteria) this;
        }

        public Criteria andFspousephoneNotEqualTo(String value) {
            addCriterion("fSpousePhone <>", value, "fspousephone");
            return (Criteria) this;
        }

        public Criteria andFspousephoneGreaterThan(String value) {
            addCriterion("fSpousePhone >", value, "fspousephone");
            return (Criteria) this;
        }

        public Criteria andFspousephoneGreaterThanOrEqualTo(String value) {
            addCriterion("fSpousePhone >=", value, "fspousephone");
            return (Criteria) this;
        }

        public Criteria andFspousephoneLessThan(String value) {
            addCriterion("fSpousePhone <", value, "fspousephone");
            return (Criteria) this;
        }

        public Criteria andFspousephoneLessThanOrEqualTo(String value) {
            addCriterion("fSpousePhone <=", value, "fspousephone");
            return (Criteria) this;
        }

        public Criteria andFspousephoneLike(String value) {
            addCriterion("fSpousePhone like", value, "fspousephone");
            return (Criteria) this;
        }

        public Criteria andFspousephoneNotLike(String value) {
            addCriterion("fSpousePhone not like", value, "fspousephone");
            return (Criteria) this;
        }

        public Criteria andFspousephoneIn(List<String> values) {
            addCriterion("fSpousePhone in", values, "fspousephone");
            return (Criteria) this;
        }

        public Criteria andFspousephoneNotIn(List<String> values) {
            addCriterion("fSpousePhone not in", values, "fspousephone");
            return (Criteria) this;
        }

        public Criteria andFspousephoneBetween(String value1, String value2) {
            addCriterion("fSpousePhone between", value1, value2, "fspousephone");
            return (Criteria) this;
        }

        public Criteria andFspousephoneNotBetween(String value1, String value2) {
            addCriterion("fSpousePhone not between", value1, value2, "fspousephone");
            return (Criteria) this;
        }

        public Criteria andFphoneIsNull() {
            addCriterion("fPhone is null");
            return (Criteria) this;
        }

        public Criteria andFphoneIsNotNull() {
            addCriterion("fPhone is not null");
            return (Criteria) this;
        }

        public Criteria andFphoneEqualTo(String value) {
            addCriterion("fPhone =", value, "fphone");
            return (Criteria) this;
        }

        public Criteria andFphoneNotEqualTo(String value) {
            addCriterion("fPhone <>", value, "fphone");
            return (Criteria) this;
        }

        public Criteria andFphoneGreaterThan(String value) {
            addCriterion("fPhone >", value, "fphone");
            return (Criteria) this;
        }

        public Criteria andFphoneGreaterThanOrEqualTo(String value) {
            addCriterion("fPhone >=", value, "fphone");
            return (Criteria) this;
        }

        public Criteria andFphoneLessThan(String value) {
            addCriterion("fPhone <", value, "fphone");
            return (Criteria) this;
        }

        public Criteria andFphoneLessThanOrEqualTo(String value) {
            addCriterion("fPhone <=", value, "fphone");
            return (Criteria) this;
        }

        public Criteria andFphoneLike(String value) {
            addCriterion("fPhone like", value, "fphone");
            return (Criteria) this;
        }

        public Criteria andFphoneNotLike(String value) {
            addCriterion("fPhone not like", value, "fphone");
            return (Criteria) this;
        }

        public Criteria andFphoneIn(List<String> values) {
            addCriterion("fPhone in", values, "fphone");
            return (Criteria) this;
        }

        public Criteria andFphoneNotIn(List<String> values) {
            addCriterion("fPhone not in", values, "fphone");
            return (Criteria) this;
        }

        public Criteria andFphoneBetween(String value1, String value2) {
            addCriterion("fPhone between", value1, value2, "fphone");
            return (Criteria) this;
        }

        public Criteria andFphoneNotBetween(String value1, String value2) {
            addCriterion("fPhone not between", value1, value2, "fphone");
            return (Criteria) this;
        }

        public Criteria andFhouseidIsNull() {
            addCriterion("fHouseID is null");
            return (Criteria) this;
        }

        public Criteria andFhouseidIsNotNull() {
            addCriterion("fHouseID is not null");
            return (Criteria) this;
        }

        public Criteria andFhouseidEqualTo(Integer value) {
            addCriterion("fHouseID =", value, "fhouseid");
            return (Criteria) this;
        }

        public Criteria andFhouseidNotEqualTo(Integer value) {
            addCriterion("fHouseID <>", value, "fhouseid");
            return (Criteria) this;
        }

        public Criteria andFhouseidGreaterThan(Integer value) {
            addCriterion("fHouseID >", value, "fhouseid");
            return (Criteria) this;
        }

        public Criteria andFhouseidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fHouseID >=", value, "fhouseid");
            return (Criteria) this;
        }

        public Criteria andFhouseidLessThan(Integer value) {
            addCriterion("fHouseID <", value, "fhouseid");
            return (Criteria) this;
        }

        public Criteria andFhouseidLessThanOrEqualTo(Integer value) {
            addCriterion("fHouseID <=", value, "fhouseid");
            return (Criteria) this;
        }

        public Criteria andFhouseidIn(List<Integer> values) {
            addCriterion("fHouseID in", values, "fhouseid");
            return (Criteria) this;
        }

        public Criteria andFhouseidNotIn(List<Integer> values) {
            addCriterion("fHouseID not in", values, "fhouseid");
            return (Criteria) this;
        }

        public Criteria andFhouseidBetween(Integer value1, Integer value2) {
            addCriterion("fHouseID between", value1, value2, "fhouseid");
            return (Criteria) this;
        }

        public Criteria andFhouseidNotBetween(Integer value1, Integer value2) {
            addCriterion("fHouseID not between", value1, value2, "fhouseid");
            return (Criteria) this;
        }

        public Criteria andFyesnoidIsNull() {
            addCriterion("fYesNoID is null");
            return (Criteria) this;
        }

        public Criteria andFyesnoidIsNotNull() {
            addCriterion("fYesNoID is not null");
            return (Criteria) this;
        }

        public Criteria andFyesnoidEqualTo(Integer value) {
            addCriterion("fYesNoID =", value, "fyesnoid");
            return (Criteria) this;
        }

        public Criteria andFyesnoidNotEqualTo(Integer value) {
            addCriterion("fYesNoID <>", value, "fyesnoid");
            return (Criteria) this;
        }

        public Criteria andFyesnoidGreaterThan(Integer value) {
            addCriterion("fYesNoID >", value, "fyesnoid");
            return (Criteria) this;
        }

        public Criteria andFyesnoidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fYesNoID >=", value, "fyesnoid");
            return (Criteria) this;
        }

        public Criteria andFyesnoidLessThan(Integer value) {
            addCriterion("fYesNoID <", value, "fyesnoid");
            return (Criteria) this;
        }

        public Criteria andFyesnoidLessThanOrEqualTo(Integer value) {
            addCriterion("fYesNoID <=", value, "fyesnoid");
            return (Criteria) this;
        }

        public Criteria andFyesnoidIn(List<Integer> values) {
            addCriterion("fYesNoID in", values, "fyesnoid");
            return (Criteria) this;
        }

        public Criteria andFyesnoidNotIn(List<Integer> values) {
            addCriterion("fYesNoID not in", values, "fyesnoid");
            return (Criteria) this;
        }

        public Criteria andFyesnoidBetween(Integer value1, Integer value2) {
            addCriterion("fYesNoID between", value1, value2, "fyesnoid");
            return (Criteria) this;
        }

        public Criteria andFyesnoidNotBetween(Integer value1, Integer value2) {
            addCriterion("fYesNoID not between", value1, value2, "fyesnoid");
            return (Criteria) this;
        }

        public Criteria andFworkunitIsNull() {
            addCriterion("fWorkUnit is null");
            return (Criteria) this;
        }

        public Criteria andFworkunitIsNotNull() {
            addCriterion("fWorkUnit is not null");
            return (Criteria) this;
        }

        public Criteria andFworkunitEqualTo(String value) {
            addCriterion("fWorkUnit =", value, "fworkunit");
            return (Criteria) this;
        }

        public Criteria andFworkunitNotEqualTo(String value) {
            addCriterion("fWorkUnit <>", value, "fworkunit");
            return (Criteria) this;
        }

        public Criteria andFworkunitGreaterThan(String value) {
            addCriterion("fWorkUnit >", value, "fworkunit");
            return (Criteria) this;
        }

        public Criteria andFworkunitGreaterThanOrEqualTo(String value) {
            addCriterion("fWorkUnit >=", value, "fworkunit");
            return (Criteria) this;
        }

        public Criteria andFworkunitLessThan(String value) {
            addCriterion("fWorkUnit <", value, "fworkunit");
            return (Criteria) this;
        }

        public Criteria andFworkunitLessThanOrEqualTo(String value) {
            addCriterion("fWorkUnit <=", value, "fworkunit");
            return (Criteria) this;
        }

        public Criteria andFworkunitLike(String value) {
            addCriterion("fWorkUnit like", value, "fworkunit");
            return (Criteria) this;
        }

        public Criteria andFworkunitNotLike(String value) {
            addCriterion("fWorkUnit not like", value, "fworkunit");
            return (Criteria) this;
        }

        public Criteria andFworkunitIn(List<String> values) {
            addCriterion("fWorkUnit in", values, "fworkunit");
            return (Criteria) this;
        }

        public Criteria andFworkunitNotIn(List<String> values) {
            addCriterion("fWorkUnit not in", values, "fworkunit");
            return (Criteria) this;
        }

        public Criteria andFworkunitBetween(String value1, String value2) {
            addCriterion("fWorkUnit between", value1, value2, "fworkunit");
            return (Criteria) this;
        }

        public Criteria andFworkunitNotBetween(String value1, String value2) {
            addCriterion("fWorkUnit not between", value1, value2, "fworkunit");
            return (Criteria) this;
        }

        public Criteria andFcaichanIsNull() {
            addCriterion("fCaiChan is null");
            return (Criteria) this;
        }

        public Criteria andFcaichanIsNotNull() {
            addCriterion("fCaiChan is not null");
            return (Criteria) this;
        }

        public Criteria andFcaichanEqualTo(String value) {
            addCriterion("fCaiChan =", value, "fcaichan");
            return (Criteria) this;
        }

        public Criteria andFcaichanNotEqualTo(String value) {
            addCriterion("fCaiChan <>", value, "fcaichan");
            return (Criteria) this;
        }

        public Criteria andFcaichanGreaterThan(String value) {
            addCriterion("fCaiChan >", value, "fcaichan");
            return (Criteria) this;
        }

        public Criteria andFcaichanGreaterThanOrEqualTo(String value) {
            addCriterion("fCaiChan >=", value, "fcaichan");
            return (Criteria) this;
        }

        public Criteria andFcaichanLessThan(String value) {
            addCriterion("fCaiChan <", value, "fcaichan");
            return (Criteria) this;
        }

        public Criteria andFcaichanLessThanOrEqualTo(String value) {
            addCriterion("fCaiChan <=", value, "fcaichan");
            return (Criteria) this;
        }

        public Criteria andFcaichanLike(String value) {
            addCriterion("fCaiChan like", value, "fcaichan");
            return (Criteria) this;
        }

        public Criteria andFcaichanNotLike(String value) {
            addCriterion("fCaiChan not like", value, "fcaichan");
            return (Criteria) this;
        }

        public Criteria andFcaichanIn(List<String> values) {
            addCriterion("fCaiChan in", values, "fcaichan");
            return (Criteria) this;
        }

        public Criteria andFcaichanNotIn(List<String> values) {
            addCriterion("fCaiChan not in", values, "fcaichan");
            return (Criteria) this;
        }

        public Criteria andFcaichanBetween(String value1, String value2) {
            addCriterion("fCaiChan between", value1, value2, "fcaichan");
            return (Criteria) this;
        }

        public Criteria andFcaichanNotBetween(String value1, String value2) {
            addCriterion("fCaiChan not between", value1, value2, "fcaichan");
            return (Criteria) this;
        }

        public Criteria andFlaiyuanIsNull() {
            addCriterion("fLaiYuan is null");
            return (Criteria) this;
        }

        public Criteria andFlaiyuanIsNotNull() {
            addCriterion("fLaiYuan is not null");
            return (Criteria) this;
        }

        public Criteria andFlaiyuanEqualTo(String value) {
            addCriterion("fLaiYuan =", value, "flaiyuan");
            return (Criteria) this;
        }

        public Criteria andFlaiyuanNotEqualTo(String value) {
            addCriterion("fLaiYuan <>", value, "flaiyuan");
            return (Criteria) this;
        }

        public Criteria andFlaiyuanGreaterThan(String value) {
            addCriterion("fLaiYuan >", value, "flaiyuan");
            return (Criteria) this;
        }

        public Criteria andFlaiyuanGreaterThanOrEqualTo(String value) {
            addCriterion("fLaiYuan >=", value, "flaiyuan");
            return (Criteria) this;
        }

        public Criteria andFlaiyuanLessThan(String value) {
            addCriterion("fLaiYuan <", value, "flaiyuan");
            return (Criteria) this;
        }

        public Criteria andFlaiyuanLessThanOrEqualTo(String value) {
            addCriterion("fLaiYuan <=", value, "flaiyuan");
            return (Criteria) this;
        }

        public Criteria andFlaiyuanLike(String value) {
            addCriterion("fLaiYuan like", value, "flaiyuan");
            return (Criteria) this;
        }

        public Criteria andFlaiyuanNotLike(String value) {
            addCriterion("fLaiYuan not like", value, "flaiyuan");
            return (Criteria) this;
        }

        public Criteria andFlaiyuanIn(List<String> values) {
            addCriterion("fLaiYuan in", values, "flaiyuan");
            return (Criteria) this;
        }

        public Criteria andFlaiyuanNotIn(List<String> values) {
            addCriterion("fLaiYuan not in", values, "flaiyuan");
            return (Criteria) this;
        }

        public Criteria andFlaiyuanBetween(String value1, String value2) {
            addCriterion("fLaiYuan between", value1, value2, "flaiyuan");
            return (Criteria) this;
        }

        public Criteria andFlaiyuanNotBetween(String value1, String value2) {
            addCriterion("fLaiYuan not between", value1, value2, "flaiyuan");
            return (Criteria) this;
        }

        public Criteria andFchengyuanIsNull() {
            addCriterion("fChengYuan is null");
            return (Criteria) this;
        }

        public Criteria andFchengyuanIsNotNull() {
            addCriterion("fChengYuan is not null");
            return (Criteria) this;
        }

        public Criteria andFchengyuanEqualTo(String value) {
            addCriterion("fChengYuan =", value, "fchengyuan");
            return (Criteria) this;
        }

        public Criteria andFchengyuanNotEqualTo(String value) {
            addCriterion("fChengYuan <>", value, "fchengyuan");
            return (Criteria) this;
        }

        public Criteria andFchengyuanGreaterThan(String value) {
            addCriterion("fChengYuan >", value, "fchengyuan");
            return (Criteria) this;
        }

        public Criteria andFchengyuanGreaterThanOrEqualTo(String value) {
            addCriterion("fChengYuan >=", value, "fchengyuan");
            return (Criteria) this;
        }

        public Criteria andFchengyuanLessThan(String value) {
            addCriterion("fChengYuan <", value, "fchengyuan");
            return (Criteria) this;
        }

        public Criteria andFchengyuanLessThanOrEqualTo(String value) {
            addCriterion("fChengYuan <=", value, "fchengyuan");
            return (Criteria) this;
        }

        public Criteria andFchengyuanLike(String value) {
            addCriterion("fChengYuan like", value, "fchengyuan");
            return (Criteria) this;
        }

        public Criteria andFchengyuanNotLike(String value) {
            addCriterion("fChengYuan not like", value, "fchengyuan");
            return (Criteria) this;
        }

        public Criteria andFchengyuanIn(List<String> values) {
            addCriterion("fChengYuan in", values, "fchengyuan");
            return (Criteria) this;
        }

        public Criteria andFchengyuanNotIn(List<String> values) {
            addCriterion("fChengYuan not in", values, "fchengyuan");
            return (Criteria) this;
        }

        public Criteria andFchengyuanBetween(String value1, String value2) {
            addCriterion("fChengYuan between", value1, value2, "fchengyuan");
            return (Criteria) this;
        }

        public Criteria andFchengyuanNotBetween(String value1, String value2) {
            addCriterion("fChengYuan not between", value1, value2, "fchengyuan");
            return (Criteria) this;
        }

        public Criteria andFrelationidIsNull() {
            addCriterion("fRelationID is null");
            return (Criteria) this;
        }

        public Criteria andFrelationidIsNotNull() {
            addCriterion("fRelationID is not null");
            return (Criteria) this;
        }

        public Criteria andFrelationidEqualTo(Integer value) {
            addCriterion("fRelationID =", value, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidNotEqualTo(Integer value) {
            addCriterion("fRelationID <>", value, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidGreaterThan(Integer value) {
            addCriterion("fRelationID >", value, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fRelationID >=", value, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidLessThan(Integer value) {
            addCriterion("fRelationID <", value, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidLessThanOrEqualTo(Integer value) {
            addCriterion("fRelationID <=", value, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidIn(List<Integer> values) {
            addCriterion("fRelationID in", values, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidNotIn(List<Integer> values) {
            addCriterion("fRelationID not in", values, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidBetween(Integer value1, Integer value2) {
            addCriterion("fRelationID between", value1, value2, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidNotBetween(Integer value1, Integer value2) {
            addCriterion("fRelationID not between", value1, value2, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidIsNull() {
            addCriterion("fRelationClassID is null");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidIsNotNull() {
            addCriterion("fRelationClassID is not null");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidEqualTo(Integer value) {
            addCriterion("fRelationClassID =", value, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidNotEqualTo(Integer value) {
            addCriterion("fRelationClassID <>", value, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidGreaterThan(Integer value) {
            addCriterion("fRelationClassID >", value, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fRelationClassID >=", value, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidLessThan(Integer value) {
            addCriterion("fRelationClassID <", value, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidLessThanOrEqualTo(Integer value) {
            addCriterion("fRelationClassID <=", value, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidIn(List<Integer> values) {
            addCriterion("fRelationClassID in", values, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidNotIn(List<Integer> values) {
            addCriterion("fRelationClassID not in", values, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidBetween(Integer value1, Integer value2) {
            addCriterion("fRelationClassID between", value1, value2, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidNotBetween(Integer value1, Integer value2) {
            addCriterion("fRelationClassID not between", value1, value2, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFishaveidIsNull() {
            addCriterion("fIsHaveID is null");
            return (Criteria) this;
        }

        public Criteria andFishaveidIsNotNull() {
            addCriterion("fIsHaveID is not null");
            return (Criteria) this;
        }

        public Criteria andFishaveidEqualTo(Integer value) {
            addCriterion("fIsHaveID =", value, "fishaveid");
            return (Criteria) this;
        }

        public Criteria andFishaveidNotEqualTo(Integer value) {
            addCriterion("fIsHaveID <>", value, "fishaveid");
            return (Criteria) this;
        }

        public Criteria andFishaveidGreaterThan(Integer value) {
            addCriterion("fIsHaveID >", value, "fishaveid");
            return (Criteria) this;
        }

        public Criteria andFishaveidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fIsHaveID >=", value, "fishaveid");
            return (Criteria) this;
        }

        public Criteria andFishaveidLessThan(Integer value) {
            addCriterion("fIsHaveID <", value, "fishaveid");
            return (Criteria) this;
        }

        public Criteria andFishaveidLessThanOrEqualTo(Integer value) {
            addCriterion("fIsHaveID <=", value, "fishaveid");
            return (Criteria) this;
        }

        public Criteria andFishaveidIn(List<Integer> values) {
            addCriterion("fIsHaveID in", values, "fishaveid");
            return (Criteria) this;
        }

        public Criteria andFishaveidNotIn(List<Integer> values) {
            addCriterion("fIsHaveID not in", values, "fishaveid");
            return (Criteria) this;
        }

        public Criteria andFishaveidBetween(Integer value1, Integer value2) {
            addCriterion("fIsHaveID between", value1, value2, "fishaveid");
            return (Criteria) this;
        }

        public Criteria andFishaveidNotBetween(Integer value1, Integer value2) {
            addCriterion("fIsHaveID not between", value1, value2, "fishaveid");
            return (Criteria) this;
        }

        public Criteria andFotherhaveidIsNull() {
            addCriterion("fOtherHaveID is null");
            return (Criteria) this;
        }

        public Criteria andFotherhaveidIsNotNull() {
            addCriterion("fOtherHaveID is not null");
            return (Criteria) this;
        }

        public Criteria andFotherhaveidEqualTo(Integer value) {
            addCriterion("fOtherHaveID =", value, "fotherhaveid");
            return (Criteria) this;
        }

        public Criteria andFotherhaveidNotEqualTo(Integer value) {
            addCriterion("fOtherHaveID <>", value, "fotherhaveid");
            return (Criteria) this;
        }

        public Criteria andFotherhaveidGreaterThan(Integer value) {
            addCriterion("fOtherHaveID >", value, "fotherhaveid");
            return (Criteria) this;
        }

        public Criteria andFotherhaveidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fOtherHaveID >=", value, "fotherhaveid");
            return (Criteria) this;
        }

        public Criteria andFotherhaveidLessThan(Integer value) {
            addCriterion("fOtherHaveID <", value, "fotherhaveid");
            return (Criteria) this;
        }

        public Criteria andFotherhaveidLessThanOrEqualTo(Integer value) {
            addCriterion("fOtherHaveID <=", value, "fotherhaveid");
            return (Criteria) this;
        }

        public Criteria andFotherhaveidIn(List<Integer> values) {
            addCriterion("fOtherHaveID in", values, "fotherhaveid");
            return (Criteria) this;
        }

        public Criteria andFotherhaveidNotIn(List<Integer> values) {
            addCriterion("fOtherHaveID not in", values, "fotherhaveid");
            return (Criteria) this;
        }

        public Criteria andFotherhaveidBetween(Integer value1, Integer value2) {
            addCriterion("fOtherHaveID between", value1, value2, "fotherhaveid");
            return (Criteria) this;
        }

        public Criteria andFotherhaveidNotBetween(Integer value1, Integer value2) {
            addCriterion("fOtherHaveID not between", value1, value2, "fotherhaveid");
            return (Criteria) this;
        }

        public Criteria andFmakebrandnoIsNull() {
            addCriterion("fMakeBrandNO is null");
            return (Criteria) this;
        }

        public Criteria andFmakebrandnoIsNotNull() {
            addCriterion("fMakeBrandNO is not null");
            return (Criteria) this;
        }

        public Criteria andFmakebrandnoEqualTo(String value) {
            addCriterion("fMakeBrandNO =", value, "fmakebrandno");
            return (Criteria) this;
        }

        public Criteria andFmakebrandnoNotEqualTo(String value) {
            addCriterion("fMakeBrandNO <>", value, "fmakebrandno");
            return (Criteria) this;
        }

        public Criteria andFmakebrandnoGreaterThan(String value) {
            addCriterion("fMakeBrandNO >", value, "fmakebrandno");
            return (Criteria) this;
        }

        public Criteria andFmakebrandnoGreaterThanOrEqualTo(String value) {
            addCriterion("fMakeBrandNO >=", value, "fmakebrandno");
            return (Criteria) this;
        }

        public Criteria andFmakebrandnoLessThan(String value) {
            addCriterion("fMakeBrandNO <", value, "fmakebrandno");
            return (Criteria) this;
        }

        public Criteria andFmakebrandnoLessThanOrEqualTo(String value) {
            addCriterion("fMakeBrandNO <=", value, "fmakebrandno");
            return (Criteria) this;
        }

        public Criteria andFmakebrandnoLike(String value) {
            addCriterion("fMakeBrandNO like", value, "fmakebrandno");
            return (Criteria) this;
        }

        public Criteria andFmakebrandnoNotLike(String value) {
            addCriterion("fMakeBrandNO not like", value, "fmakebrandno");
            return (Criteria) this;
        }

        public Criteria andFmakebrandnoIn(List<String> values) {
            addCriterion("fMakeBrandNO in", values, "fmakebrandno");
            return (Criteria) this;
        }

        public Criteria andFmakebrandnoNotIn(List<String> values) {
            addCriterion("fMakeBrandNO not in", values, "fmakebrandno");
            return (Criteria) this;
        }

        public Criteria andFmakebrandnoBetween(String value1, String value2) {
            addCriterion("fMakeBrandNO between", value1, value2, "fmakebrandno");
            return (Criteria) this;
        }

        public Criteria andFmakebrandnoNotBetween(String value1, String value2) {
            addCriterion("fMakeBrandNO not between", value1, value2, "fmakebrandno");
            return (Criteria) this;
        }

        public Criteria andFotherbrandnoIsNull() {
            addCriterion("fOtherBrandNO is null");
            return (Criteria) this;
        }

        public Criteria andFotherbrandnoIsNotNull() {
            addCriterion("fOtherBrandNO is not null");
            return (Criteria) this;
        }

        public Criteria andFotherbrandnoEqualTo(String value) {
            addCriterion("fOtherBrandNO =", value, "fotherbrandno");
            return (Criteria) this;
        }

        public Criteria andFotherbrandnoNotEqualTo(String value) {
            addCriterion("fOtherBrandNO <>", value, "fotherbrandno");
            return (Criteria) this;
        }

        public Criteria andFotherbrandnoGreaterThan(String value) {
            addCriterion("fOtherBrandNO >", value, "fotherbrandno");
            return (Criteria) this;
        }

        public Criteria andFotherbrandnoGreaterThanOrEqualTo(String value) {
            addCriterion("fOtherBrandNO >=", value, "fotherbrandno");
            return (Criteria) this;
        }

        public Criteria andFotherbrandnoLessThan(String value) {
            addCriterion("fOtherBrandNO <", value, "fotherbrandno");
            return (Criteria) this;
        }

        public Criteria andFotherbrandnoLessThanOrEqualTo(String value) {
            addCriterion("fOtherBrandNO <=", value, "fotherbrandno");
            return (Criteria) this;
        }

        public Criteria andFotherbrandnoLike(String value) {
            addCriterion("fOtherBrandNO like", value, "fotherbrandno");
            return (Criteria) this;
        }

        public Criteria andFotherbrandnoNotLike(String value) {
            addCriterion("fOtherBrandNO not like", value, "fotherbrandno");
            return (Criteria) this;
        }

        public Criteria andFotherbrandnoIn(List<String> values) {
            addCriterion("fOtherBrandNO in", values, "fotherbrandno");
            return (Criteria) this;
        }

        public Criteria andFotherbrandnoNotIn(List<String> values) {
            addCriterion("fOtherBrandNO not in", values, "fotherbrandno");
            return (Criteria) this;
        }

        public Criteria andFotherbrandnoBetween(String value1, String value2) {
            addCriterion("fOtherBrandNO between", value1, value2, "fotherbrandno");
            return (Criteria) this;
        }

        public Criteria andFotherbrandnoNotBetween(String value1, String value2) {
            addCriterion("fOtherBrandNO not between", value1, value2, "fotherbrandno");
            return (Criteria) this;
        }

        public Criteria andFweixinIsNull() {
            addCriterion("fWeiXin is null");
            return (Criteria) this;
        }

        public Criteria andFweixinIsNotNull() {
            addCriterion("fWeiXin is not null");
            return (Criteria) this;
        }

        public Criteria andFweixinEqualTo(String value) {
            addCriterion("fWeiXin =", value, "fweixin");
            return (Criteria) this;
        }

        public Criteria andFweixinNotEqualTo(String value) {
            addCriterion("fWeiXin <>", value, "fweixin");
            return (Criteria) this;
        }

        public Criteria andFweixinGreaterThan(String value) {
            addCriterion("fWeiXin >", value, "fweixin");
            return (Criteria) this;
        }

        public Criteria andFweixinGreaterThanOrEqualTo(String value) {
            addCriterion("fWeiXin >=", value, "fweixin");
            return (Criteria) this;
        }

        public Criteria andFweixinLessThan(String value) {
            addCriterion("fWeiXin <", value, "fweixin");
            return (Criteria) this;
        }

        public Criteria andFweixinLessThanOrEqualTo(String value) {
            addCriterion("fWeiXin <=", value, "fweixin");
            return (Criteria) this;
        }

        public Criteria andFweixinLike(String value) {
            addCriterion("fWeiXin like", value, "fweixin");
            return (Criteria) this;
        }

        public Criteria andFweixinNotLike(String value) {
            addCriterion("fWeiXin not like", value, "fweixin");
            return (Criteria) this;
        }

        public Criteria andFweixinIn(List<String> values) {
            addCriterion("fWeiXin in", values, "fweixin");
            return (Criteria) this;
        }

        public Criteria andFweixinNotIn(List<String> values) {
            addCriterion("fWeiXin not in", values, "fweixin");
            return (Criteria) this;
        }

        public Criteria andFweixinBetween(String value1, String value2) {
            addCriterion("fWeiXin between", value1, value2, "fweixin");
            return (Criteria) this;
        }

        public Criteria andFweixinNotBetween(String value1, String value2) {
            addCriterion("fWeiXin not between", value1, value2, "fweixin");
            return (Criteria) this;
        }

        public Criteria andFtypeidIsNull() {
            addCriterion("fTypeID is null");
            return (Criteria) this;
        }

        public Criteria andFtypeidIsNotNull() {
            addCriterion("fTypeID is not null");
            return (Criteria) this;
        }

        public Criteria andFtypeidEqualTo(Integer value) {
            addCriterion("fTypeID =", value, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidNotEqualTo(Integer value) {
            addCriterion("fTypeID <>", value, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidGreaterThan(Integer value) {
            addCriterion("fTypeID >", value, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fTypeID >=", value, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidLessThan(Integer value) {
            addCriterion("fTypeID <", value, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidLessThanOrEqualTo(Integer value) {
            addCriterion("fTypeID <=", value, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidIn(List<Integer> values) {
            addCriterion("fTypeID in", values, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidNotIn(List<Integer> values) {
            addCriterion("fTypeID not in", values, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidBetween(Integer value1, Integer value2) {
            addCriterion("fTypeID between", value1, value2, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidNotBetween(Integer value1, Integer value2) {
            addCriterion("fTypeID not between", value1, value2, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFopenidIsNull() {
            addCriterion("fOpenID is null");
            return (Criteria) this;
        }

        public Criteria andFopenidIsNotNull() {
            addCriterion("fOpenID is not null");
            return (Criteria) this;
        }

        public Criteria andFopenidEqualTo(String value) {
            addCriterion("fOpenID =", value, "fopenid");
            return (Criteria) this;
        }

        public Criteria andFopenidNotEqualTo(String value) {
            addCriterion("fOpenID <>", value, "fopenid");
            return (Criteria) this;
        }

        public Criteria andFopenidGreaterThan(String value) {
            addCriterion("fOpenID >", value, "fopenid");
            return (Criteria) this;
        }

        public Criteria andFopenidGreaterThanOrEqualTo(String value) {
            addCriterion("fOpenID >=", value, "fopenid");
            return (Criteria) this;
        }

        public Criteria andFopenidLessThan(String value) {
            addCriterion("fOpenID <", value, "fopenid");
            return (Criteria) this;
        }

        public Criteria andFopenidLessThanOrEqualTo(String value) {
            addCriterion("fOpenID <=", value, "fopenid");
            return (Criteria) this;
        }

        public Criteria andFopenidLike(String value) {
            addCriterion("fOpenID like", value, "fopenid");
            return (Criteria) this;
        }

        public Criteria andFopenidNotLike(String value) {
            addCriterion("fOpenID not like", value, "fopenid");
            return (Criteria) this;
        }

        public Criteria andFopenidIn(List<String> values) {
            addCriterion("fOpenID in", values, "fopenid");
            return (Criteria) this;
        }

        public Criteria andFopenidNotIn(List<String> values) {
            addCriterion("fOpenID not in", values, "fopenid");
            return (Criteria) this;
        }

        public Criteria andFopenidBetween(String value1, String value2) {
            addCriterion("fOpenID between", value1, value2, "fopenid");
            return (Criteria) this;
        }

        public Criteria andFopenidNotBetween(String value1, String value2) {
            addCriterion("fOpenID not between", value1, value2, "fopenid");
            return (Criteria) this;
        }

        public Criteria andFinteridIsNull() {
            addCriterion("fInterID is null");
            return (Criteria) this;
        }

        public Criteria andFinteridIsNotNull() {
            addCriterion("fInterID is not null");
            return (Criteria) this;
        }

        public Criteria andFinteridEqualTo(Integer value) {
            addCriterion("fInterID =", value, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridNotEqualTo(Integer value) {
            addCriterion("fInterID <>", value, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridGreaterThan(Integer value) {
            addCriterion("fInterID >", value, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridGreaterThanOrEqualTo(Integer value) {
            addCriterion("fInterID >=", value, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridLessThan(Integer value) {
            addCriterion("fInterID <", value, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridLessThanOrEqualTo(Integer value) {
            addCriterion("fInterID <=", value, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridIn(List<Integer> values) {
            addCriterion("fInterID in", values, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridNotIn(List<Integer> values) {
            addCriterion("fInterID not in", values, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridBetween(Integer value1, Integer value2) {
            addCriterion("fInterID between", value1, value2, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridNotBetween(Integer value1, Integer value2) {
            addCriterion("fInterID not between", value1, value2, "finterid");
            return (Criteria) this;
        }

        public Criteria andFentryidIsNull() {
            addCriterion("fEntryID is null");
            return (Criteria) this;
        }

        public Criteria andFentryidIsNotNull() {
            addCriterion("fEntryID is not null");
            return (Criteria) this;
        }

        public Criteria andFentryidEqualTo(Integer value) {
            addCriterion("fEntryID =", value, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidNotEqualTo(Integer value) {
            addCriterion("fEntryID <>", value, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidGreaterThan(Integer value) {
            addCriterion("fEntryID >", value, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fEntryID >=", value, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidLessThan(Integer value) {
            addCriterion("fEntryID <", value, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidLessThanOrEqualTo(Integer value) {
            addCriterion("fEntryID <=", value, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidIn(List<Integer> values) {
            addCriterion("fEntryID in", values, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidNotIn(List<Integer> values) {
            addCriterion("fEntryID not in", values, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidBetween(Integer value1, Integer value2) {
            addCriterion("fEntryID between", value1, value2, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidNotBetween(Integer value1, Integer value2) {
            addCriterion("fEntryID not between", value1, value2, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFcheckdateIsNull() {
            addCriterion("fCheckDate is null");
            return (Criteria) this;
        }

        public Criteria andFcheckdateIsNotNull() {
            addCriterion("fCheckDate is not null");
            return (Criteria) this;
        }

        public Criteria andFcheckdateEqualTo(Date value) {
            addCriterion("fCheckDate =", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateNotEqualTo(Date value) {
            addCriterion("fCheckDate <>", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateGreaterThan(Date value) {
            addCriterion("fCheckDate >", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateGreaterThanOrEqualTo(Date value) {
            addCriterion("fCheckDate >=", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateLessThan(Date value) {
            addCriterion("fCheckDate <", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateLessThanOrEqualTo(Date value) {
            addCriterion("fCheckDate <=", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateIn(List<Date> values) {
            addCriterion("fCheckDate in", values, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateNotIn(List<Date> values) {
            addCriterion("fCheckDate not in", values, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateBetween(Date value1, Date value2) {
            addCriterion("fCheckDate between", value1, value2, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateNotBetween(Date value1, Date value2) {
            addCriterion("fCheckDate not between", value1, value2, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFstatusEqualTo(int value) {
            addCriterion("fStatus =", value, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusNotEqualTo(int value) {
            addCriterion("fStatus <>", value, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusGreaterThan(int value) {
            addCriterion("fStatus >", value, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusGreaterThanOrEqualTo(int value) {
            addCriterion("fStatus >=", value, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusLessThan(int value) {
            addCriterion("fStatus <", value, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusLessThanOrEqualTo(int value) {
            addCriterion("fStatus <=", value, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusBetween(int value1, int value2) {
            addCriterion("fStatus between", value1, value2, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusNotBetween(int value1, int value2) {
            addCriterion("fStatus not between", value1, value2, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidEqualTo(int value) {
            addCriterion("fRunStatusID =", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidNotEqualTo(int value) {
            addCriterion("fRunStatusID <>", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidGreaterThan(int value) {
            addCriterion("fRunStatusID >", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidGreaterThanOrEqualTo(int value) {
            addCriterion("fRunStatusID >=", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidLessThan(int value) {
            addCriterion("fRunStatusID <", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidLessThanOrEqualTo(int value) {
            addCriterion("fRunStatusID <=", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidBetween(int value1, int value2) {
            addCriterion("fRunStatusID between", value1, value2, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidNotBetween(int value1, int value2) {
            addCriterion("fRunStatusID not between", value1, value2, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidEqualTo(int value) {
            addCriterion("fStatusID =", value, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidNotEqualTo(int value) {
            addCriterion("fStatusID <>", value, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidGreaterThan(int value) {
            addCriterion("fStatusID >", value, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidGreaterThanOrEqualTo(int value) {
            addCriterion("fStatusID >=", value, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidLessThan(int value) {
            addCriterion("fStatusID <", value, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidLessThanOrEqualTo(int value) {
            addCriterion("fStatusID <=", value, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidBetween(int value1, int value2) {
            addCriterion("fStatusID between", value1, value2, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidNotBetween(int value1, int value2) {
            addCriterion("fStatusID not between", value1, value2, "fstatusid");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}